CREATE TABLE 'TRANS' (
'mdata' TIMESTAMP default NULL,
'fullname' TEXT(8) NOT NULL default '',
'id' TIMESTAMP default '',
'DOB' MEDIUMINT default NULL,
'middlename' VARCHAR NOT NULL default ''
);